Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 602987 |
| Missing cells | 3033695 |
| Missing cells (%) | 16.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 142.6 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| Categorical | 5 |
| Text | 6 |
CANCELLED is highly imbalanced (88.6%) | Imbalance |
DIVERTED is highly imbalanced (97.2%) | Imbalance |
DEP_TIME has 8883 (1.5%) missing values | Missing |
DEP_DELAY has 8886 (1.5%) missing values | Missing |
TAXI_OUT has 9137 (1.5%) missing values | Missing |
TAXI_IN has 9272 (1.5%) missing values | Missing |
ARR_TIME has 9272 (1.5%) missing values | Missing |
ARR_DELAY has 10845 (1.8%) missing values | Missing |
CANCELLATION_CODE has 593815 (98.5%) missing values | Missing |
AIR_TIME has 10845 (1.8%) missing values | Missing |
CARRIER_DELAY has 474548 (78.7%) missing values | Missing |
WEATHER_DELAY has 474548 (78.7%) missing values | Missing |
NAS_DELAY has 474548 (78.7%) missing values | Missing |
SECURITY_DELAY has 474548 (78.7%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 474548 (78.7%) missing values | Missing |
SECURITY_DELAY is highly skewed (γ1 = 101.1322251) | Skewed |
DEP_DELAY has 26621 (4.4%) zeros | Zeros |
ARR_DELAY has 10607 (1.8%) zeros | Zeros |
CARRIER_DELAY has 55325 (9.2%) zeros | Zeros |
WEATHER_DELAY has 120952 (20.1%) zeros | Zeros |
NAS_DELAY has 72188 (12.0%) zeros | Zeros |
SECURITY_DELAY has 127603 (21.2%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 59380 (9.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 05:41:44.711952 |
|---|---|
| Analysis finished | 2024-03-30 05:45:12.112895 |
| Duration | 3 minutes and 27.4 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8849843 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.9382999 |
|---|---|
| Coefficient of variation (CV) | 0.49892091 |
| Kurtosis | -1.146095 |
| Mean | 3.8849843 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.12021948 |
| Sum | 2342595 |
| Variance | 3.7570065 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 4 | 100666 | |
| 3 | 96397 | |
| 2 | 95349 | |
| 5 | 80493 | |
| 1 | 80312 | |
| 7 | 78645 | |
| 6 | 71125 |
| Value | Count | Frequency (%) |
| 1 | 80312 | |
| 2 | 95349 | |
| 3 | 96397 | |
| 4 | 100666 | |
| 5 | 80493 | |
| 6 | 71125 | |
| 7 | 78645 |
| Value | Count | Frequency (%) |
| 7 | 78645 | |
| 6 | 71125 | |
| 5 | 80493 | |
| 4 | 100666 | |
| 3 | 96397 | |
| 2 | 95349 | |
| 1 | 80312 |
FL_DATE
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 8/3/2023 12:00:00 AM | 20435 |
|---|---|
| 8/10/2023 12:00:00 AM | 20394 |
| 8/4/2023 12:00:00 AM | 20378 |
| 8/11/2023 12:00:00 AM | 20356 |
| 8/7/2023 12:00:00 AM | 20318 |
| Other values (26) |
Length
| Max length | 21 |
|---|---|
| Median length | 21 |
| Mean length | 20.707466 |
| Min length | 20 |
Characters and Unicode
| Total characters | 12486333 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 8/7/2023 12:00:00 AM |
|---|---|
| 2nd row | 8/7/2023 12:00:00 AM |
| 3rd row | 8/7/2023 12:00:00 AM |
| 4th row | 8/7/2023 12:00:00 AM |
| 5th row | 8/7/2023 12:00:00 AM |
Common Values
| Value | Count | Frequency (%) |
| 8/3/2023 12:00:00 AM | 20435 | 3.4% |
| 8/10/2023 12:00:00 AM | 20394 | 3.4% |
| 8/4/2023 12:00:00 AM | 20378 | 3.4% |
| 8/11/2023 12:00:00 AM | 20356 | 3.4% |
| 8/7/2023 12:00:00 AM | 20318 | 3.4% |
| 8/14/2023 12:00:00 AM | 20280 | 3.4% |
| 8/17/2023 12:00:00 AM | 19989 | 3.3% |
| 8/31/2023 12:00:00 AM | 19927 | 3.3% |
| 8/18/2023 12:00:00 AM | 19923 | 3.3% |
| 8/24/2023 12:00:00 AM | 19921 | 3.3% |
| Other values (21) | 401066 |
Length
| Value | Count | Frequency (%) |
| 12:00:00 | 602987 | |
| am | 602987 | |
| 8/3/2023 | 20435 | 1.1% |
| 8/10/2023 | 20394 | 1.1% |
| 8/4/2023 | 20378 | 1.1% |
| 8/11/2023 | 20356 | 1.1% |
| 8/7/2023 | 20318 | 1.1% |
| 8/14/2023 | 20280 | 1.1% |
| 8/17/2023 | 19989 | 1.1% |
| 8/31/2023 | 19927 | 1.1% |
| Other values (23) | 440910 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3074006 | |
| 2 | 2058591 | |
| / | 1205974 | 9.7% |
| 1205974 | 9.7% | |
| : | 1205974 | 9.7% |
| 1 | 876756 | 7.0% |
| 3 | 701291 | 5.6% |
| 8 | 662030 | 5.3% |
| A | 602987 | 4.8% |
| M | 602987 | 4.8% |
| Other values (5) | 289763 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12486333 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3074006 | |
| 2 | 2058591 | |
| / | 1205974 | 9.7% |
| 1205974 | 9.7% | |
| : | 1205974 | 9.7% |
| 1 | 876756 | 7.0% |
| 3 | 701291 | 5.6% |
| 8 | 662030 | 5.3% |
| A | 602987 | 4.8% |
| M | 602987 | 4.8% |
| Other values (5) | 289763 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12486333 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3074006 | |
| 2 | 2058591 | |
| / | 1205974 | 9.7% |
| 1205974 | 9.7% | |
| : | 1205974 | 9.7% |
| 1 | 876756 | 7.0% |
| 3 | 701291 | 5.6% |
| 8 | 662030 | 5.3% |
| A | 602987 | 4.8% |
| M | 602987 | 4.8% |
| Other values (5) | 289763 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12486333 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3074006 | |
| 2 | 2058591 | |
| / | 1205974 | 9.7% |
| 1205974 | 9.7% | |
| : | 1205974 | 9.7% |
| 1 | 876756 | 7.0% |
| 3 | 701291 | 5.6% |
| 8 | 662030 | 5.3% |
| A | 602987 | 4.8% |
| M | 602987 | 4.8% |
| Other values (5) | 289763 | 2.3% |
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1205974 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 125664 | |
| DL | 89057 | |
| AA | 85157 | |
| UA | 66801 | |
| OO | 58093 | |
| YX | 24333 | 4.0% |
| AS | 22974 | 3.8% |
| B6 | 22895 | 3.8% |
| NK | 21514 | 3.6% |
| MQ | 20359 | 3.4% |
| Other values (5) | 66140 |
Length
| Value | Count | Frequency (%) |
| wn | 125664 | |
| dl | 89057 | |
| aa | 85157 | |
| ua | 66801 | |
| oo | 58093 | |
| yx | 24333 | 4.0% |
| as | 22974 | 3.8% |
| b6 | 22895 | 3.8% |
| nk | 21514 | 3.6% |
| mq | 20359 | 3.4% |
| Other values (5) | 66140 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 267113 | |
| N | 147178 | |
| O | 132963 | |
| W | 125664 | |
| D | 89057 | 7.4% |
| L | 89057 | 7.4% |
| U | 66801 | 5.5% |
| 9 | 33526 | 2.8% |
| Y | 24333 | 2.0% |
| X | 24333 | 2.0% |
| Other values (11) | 205949 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1205974 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 267113 | |
| N | 147178 | |
| O | 132963 | |
| W | 125664 | |
| D | 89057 | 7.4% |
| L | 89057 | 7.4% |
| U | 66801 | 5.5% |
| 9 | 33526 | 2.8% |
| Y | 24333 | 2.0% |
| X | 24333 | 2.0% |
| Other values (11) | 205949 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1205974 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 267113 | |
| N | 147178 | |
| O | 132963 | |
| W | 125664 | |
| D | 89057 | 7.4% |
| L | 89057 | 7.4% |
| U | 66801 | 5.5% |
| 9 | 33526 | 2.8% |
| Y | 24333 | 2.0% |
| X | 24333 | 2.0% |
| Other values (11) | 205949 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1205974 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 267113 | |
| N | 147178 | |
| O | 132963 | |
| W | 125664 | |
| D | 89057 | 7.4% |
| L | 89057 | 7.4% |
| U | 66801 | 5.5% |
| 9 | 33526 | 2.8% |
| Y | 24333 | 2.0% |
| X | 24333 | 2.0% |
| Other values (11) | 205949 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5919 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2338.6403 |
| Minimum | 1 |
|---|---|
| Maximum | 8810 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 286 |
| Q1 | 1048 |
| median | 2094 |
| Q3 | 3410 |
| 95-th percentile | 5388 |
| Maximum | 8810 |
| Range | 8809 |
| Interquartile range (IQR) | 2362 |
Descriptive statistics
| Standard deviation | 1580.5123 |
|---|---|
| Coefficient of variation (CV) | 0.67582531 |
| Kurtosis | -0.66989294 |
| Mean | 2338.6403 |
| Median Absolute Deviation (MAD) | 1146 |
| Skewness | 0.564843 |
| Sum | 1.4101697 × 109 |
| Variance | 2498019.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 648 | 351 | 0.1% |
| 323 | 339 | 0.1% |
| 358 | 316 | 0.1% |
| 1150 | 310 | 0.1% |
| 555 | 302 | 0.1% |
| 677 | 301 | < 0.1% |
| 591 | 298 | < 0.1% |
| 777 | 297 | < 0.1% |
| 312 | 297 | < 0.1% |
| 354 | 293 | < 0.1% |
| Other values (5909) | 599883 |
| Value | Count | Frequency (%) |
| 1 | 193 | |
| 2 | 172 | |
| 3 | 97 | |
| 4 | 145 | |
| 5 | 99 | |
| 6 | 77 | < 0.1% |
| 7 | 191 | |
| 8 | 104 | |
| 9 | 164 | |
| 10 | 198 |
| Value | Count | Frequency (%) |
| 8810 | 1 | < 0.1% |
| 8789 | 1 | < 0.1% |
| 8788 | 1 | < 0.1% |
| 8785 | 2 | < 0.1% |
| 8784 | 4 | |
| 8783 | 4 | |
| 8771 | 5 | |
| 8770 | 8 | |
| 6856 | 2 | < 0.1% |
| 6688 | 2 | < 0.1% |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 337 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12640.889 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 13964 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2672 |
Descriptive statistics
| Standard deviation | 1532.9791 |
|---|---|
| Coefficient of variation (CV) | 0.12127146 |
| Kurtosis | -1.3029086 |
| Mean | 12640.889 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11319848 |
| Sum | 7.6222915 × 109 |
| Variance | 2350024.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 29431 | 4.9% |
| 11298 | 26370 | 4.4% |
| 11292 | 26308 | 4.4% |
| 13930 | 23347 | 3.9% |
| 12892 | 17683 | 2.9% |
| 11057 | 17319 | 2.9% |
| 14747 | 15974 | 2.6% |
| 12889 | 15939 | 2.6% |
| 14107 | 14304 | 2.4% |
| 12953 | 14074 | 2.3% |
| Other values (327) | 402238 |
| Value | Count | Frequency (%) |
| 10135 | 398 | 0.1% |
| 10136 | 122 | < 0.1% |
| 10140 | 2172 | |
| 10141 | 62 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10154 | 406 | 0.1% |
| 10155 | 93 | < 0.1% |
| 10157 | 88 | < 0.1% |
| 10158 | 248 | < 0.1% |
| 10165 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 155 | < 0.1% |
| 16218 | 171 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 1059 | |
| 15897 | 60 | < 0.1% |
| 15841 | 62 | < 0.1% |
| 15624 | 855 | |
| 15607 | 62 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15569 | 53 | < 0.1% |
ORIGIN
Text
| Distinct | 337 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1808961 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RIC |
|---|---|
| 2nd row | CLT |
| 3rd row | JFK |
| 4th row | SYR |
| 5th row | BHM |
| Value | Count | Frequency (%) |
| atl | 29431 | 4.9% |
| dfw | 26370 | 4.4% |
| den | 26308 | 4.4% |
| ord | 23347 | 3.9% |
| lax | 17683 | 2.9% |
| clt | 17319 | 2.9% |
| sea | 15974 | 2.6% |
| las | 15939 | 2.6% |
| phx | 14304 | 2.4% |
| lga | 14074 | 2.3% |
| Other values (327) | 402238 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 206729 | 11.4% |
| L | 165469 | 9.1% |
| S | 154148 | 8.5% |
| D | 145224 | 8.0% |
| T | 95173 | 5.3% |
| O | 92352 | 5.1% |
| C | 91863 | 5.1% |
| M | 81220 | 4.5% |
| F | 75118 | 4.2% |
| W | 71351 | 3.9% |
| Other values (16) | 630314 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 206729 | 11.4% |
| L | 165469 | 9.1% |
| S | 154148 | 8.5% |
| D | 145224 | 8.0% |
| T | 95173 | 5.3% |
| O | 92352 | 5.1% |
| C | 91863 | 5.1% |
| M | 81220 | 4.5% |
| F | 75118 | 4.2% |
| W | 71351 | 3.9% |
| Other values (16) | 630314 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 206729 | 11.4% |
| L | 165469 | 9.1% |
| S | 154148 | 8.5% |
| D | 145224 | 8.0% |
| T | 95173 | 5.3% |
| O | 92352 | 5.1% |
| C | 91863 | 5.1% |
| M | 81220 | 4.5% |
| F | 75118 | 4.2% |
| W | 71351 | 3.9% |
| Other values (16) | 630314 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 206729 | 11.4% |
| L | 165469 | 9.1% |
| S | 154148 | 8.5% |
| D | 145224 | 8.0% |
| T | 95173 | 5.3% |
| O | 92352 | 5.1% |
| C | 91863 | 5.1% |
| M | 81220 | 4.5% |
| F | 75118 | 4.2% |
| W | 71351 | 3.9% |
| Other values (16) | 630314 |
ORIGIN_CITY_NAME
Text
| Distinct | 331 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.045402 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7866208 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Richmond, VA |
|---|---|
| 2nd row | Charlotte, NC |
| 3rd row | New York, NY |
| 4th row | Syracuse, NY |
| 5th row | Birmingham, AL |
| Value | Count | Frequency (%) |
| ca | 65593 | 4.7% |
| tx | 64539 | 4.6% |
| fl | 48079 | 3.4% |
| il | 32293 | 2.3% |
| ny | 32086 | 2.3% |
| san | 32015 | 2.3% |
| ga | 31445 | 2.2% |
| chicago | 31237 | 2.2% |
| atlanta | 29431 | 2.1% |
| co | 29204 | 2.1% |
| Other values (402) | 1006171 |
Most occurring characters
| Value | Count | Frequency (%) |
| 799106 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600313 | 7.6% |
| o | 434154 | 5.5% |
| e | 415330 | 5.3% |
| n | 387029 | 4.9% |
| t | 379152 | 4.8% |
| l | 350472 | 4.5% |
| i | 300076 | 3.8% |
| r | 283229 | 3.6% |
| Other values (47) | 3314360 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7866208 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 799106 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600313 | 7.6% |
| o | 434154 | 5.5% |
| e | 415330 | 5.3% |
| n | 387029 | 4.9% |
| t | 379152 | 4.8% |
| l | 350472 | 4.5% |
| i | 300076 | 3.8% |
| r | 283229 | 3.6% |
| Other values (47) | 3314360 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7866208 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 799106 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600313 | 7.6% |
| o | 434154 | 5.5% |
| e | 415330 | 5.3% |
| n | 387029 | 4.9% |
| t | 379152 | 4.8% |
| l | 350472 | 4.5% |
| i | 300076 | 3.8% |
| r | 283229 | 3.6% |
| Other values (47) | 3314360 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7866208 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 799106 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600313 | 7.6% |
| o | 434154 | 5.5% |
| e | 415330 | 5.3% |
| n | 387029 | 4.9% |
| t | 379152 | 4.8% |
| l | 350472 | 4.5% |
| i | 300076 | 3.8% |
| r | 283229 | 3.6% |
| Other values (47) | 3314360 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.178576 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4931575 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Virginia |
|---|---|
| 2nd row | North Carolina |
| 3rd row | New York |
| 4th row | New York |
| 5th row | Alabama |
| Value | Count | Frequency (%) |
| california | 65593 | 9.5% |
| texas | 64539 | 9.3% |
| florida | 48079 | 7.0% |
| new | 47086 | 6.8% |
| illinois | 32293 | 4.7% |
| york | 32086 | 4.6% |
| carolina | 31663 | 4.6% |
| georgia | 31445 | 4.6% |
| colorado | 29204 | 4.2% |
| north | 27359 | 4.0% |
| Other values (51) | 281322 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 662896 | |
| i | 553735 | 11.2% |
| o | 472650 | 9.6% |
| n | 369976 | 7.5% |
| r | 351577 | 7.1% |
| e | 300814 | 6.1% |
| s | 286836 | 5.8% |
| l | 272845 | 5.5% |
| C | 128292 | 2.6% |
| t | 120586 | 2.4% |
| Other values (37) | 1411368 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4931575 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 662896 | |
| i | 553735 | 11.2% |
| o | 472650 | 9.6% |
| n | 369976 | 7.5% |
| r | 351577 | 7.1% |
| e | 300814 | 6.1% |
| s | 286836 | 5.8% |
| l | 272845 | 5.5% |
| C | 128292 | 2.6% |
| t | 120586 | 2.4% |
| Other values (37) | 1411368 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4931575 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 662896 | |
| i | 553735 | 11.2% |
| o | 472650 | 9.6% |
| n | 369976 | 7.5% |
| r | 351577 | 7.1% |
| e | 300814 | 6.1% |
| s | 286836 | 5.8% |
| l | 272845 | 5.5% |
| C | 128292 | 2.6% |
| t | 120586 | 2.4% |
| Other values (37) | 1411368 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4931575 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 662896 | |
| i | 553735 | 11.2% |
| o | 472650 | 9.6% |
| n | 369976 | 7.5% |
| r | 351577 | 7.1% |
| e | 300814 | 6.1% |
| s | 286836 | 5.8% |
| l | 272845 | 5.5% |
| C | 128292 | 2.6% |
| t | 120586 | 2.4% |
| Other values (37) | 1411368 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.728618 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.917018 |
|---|---|
| Coefficient of variation (CV) | 0.49182712 |
| Kurtosis | -1.308255 |
| Mean | 54.728618 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.04997092 |
| Sum | 33000645 |
| Variance | 724.52587 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 65593 | 10.9% |
| 74 | 64539 | 10.7% |
| 33 | 48079 | 8.0% |
| 41 | 32293 | 5.4% |
| 22 | 32086 | 5.3% |
| 34 | 31445 | 5.2% |
| 82 | 29204 | 4.8% |
| 36 | 25938 | 4.3% |
| 38 | 20974 | 3.5% |
| 93 | 18186 | 3.0% |
| Other values (42) | 234650 |
| Value | Count | Frequency (%) |
| 1 | 4060 | 0.7% |
| 2 | 11661 | |
| 3 | 3475 | 0.6% |
| 4 | 403 | 0.1% |
| 5 | 125 | < 0.1% |
| 11 | 1832 | 0.3% |
| 12 | 1792 | 0.3% |
| 13 | 13298 | |
| 14 | 601 | 0.1% |
| 15 | 1237 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 18186 | 3.0% |
| 92 | 6912 | 1.1% |
| 91 | 65593 | |
| 88 | 990 | 0.2% |
| 87 | 10134 | 1.7% |
| 86 | 2389 | 0.4% |
| 85 | 17861 | 3.0% |
| 84 | 2756 | 0.5% |
| 83 | 2357 | 0.4% |
| 82 | 29204 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 337 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12640.892 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 13964 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2672 |
Descriptive statistics
| Standard deviation | 1532.948 |
|---|---|
| Coefficient of variation (CV) | 0.12126897 |
| Kurtosis | -1.3028379 |
| Mean | 12640.892 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11324882 |
| Sum | 7.6222937 × 109 |
| Variance | 2349929.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 29428 | 4.9% |
| 11298 | 26371 | 4.4% |
| 11292 | 26300 | 4.4% |
| 13930 | 23346 | 3.9% |
| 12892 | 17685 | 2.9% |
| 11057 | 17323 | 2.9% |
| 14747 | 15968 | 2.6% |
| 12889 | 15937 | 2.6% |
| 14107 | 14304 | 2.4% |
| 12953 | 14074 | 2.3% |
| Other values (327) | 402251 |
| Value | Count | Frequency (%) |
| 10135 | 398 | 0.1% |
| 10136 | 122 | < 0.1% |
| 10140 | 2171 | |
| 10141 | 62 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10154 | 406 | 0.1% |
| 10155 | 93 | < 0.1% |
| 10157 | 88 | < 0.1% |
| 10158 | 248 | < 0.1% |
| 10165 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 155 | < 0.1% |
| 16218 | 171 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 1059 | |
| 15897 | 60 | < 0.1% |
| 15841 | 62 | < 0.1% |
| 15624 | 855 | |
| 15607 | 62 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15569 | 53 | < 0.1% |
DEST
Text
| Distinct | 337 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1808961 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MSP |
|---|---|
| 2nd row | JFK |
| 3rd row | CLT |
| 4th row | DTW |
| 5th row | LGA |
| Value | Count | Frequency (%) |
| atl | 29428 | 4.9% |
| dfw | 26371 | 4.4% |
| den | 26300 | 4.4% |
| ord | 23346 | 3.9% |
| lax | 17685 | 2.9% |
| clt | 17323 | 2.9% |
| sea | 15968 | 2.6% |
| las | 15937 | 2.6% |
| phx | 14304 | 2.4% |
| lga | 14074 | 2.3% |
| Other values (327) | 402251 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 206719 | 11.4% |
| L | 165496 | 9.1% |
| S | 154137 | 8.5% |
| D | 145228 | 8.0% |
| T | 95175 | 5.3% |
| O | 92338 | 5.1% |
| C | 91863 | 5.1% |
| M | 81221 | 4.5% |
| F | 75128 | 4.2% |
| W | 71354 | 3.9% |
| Other values (16) | 630302 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 206719 | 11.4% |
| L | 165496 | 9.1% |
| S | 154137 | 8.5% |
| D | 145228 | 8.0% |
| T | 95175 | 5.3% |
| O | 92338 | 5.1% |
| C | 91863 | 5.1% |
| M | 81221 | 4.5% |
| F | 75128 | 4.2% |
| W | 71354 | 3.9% |
| Other values (16) | 630302 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 206719 | 11.4% |
| L | 165496 | 9.1% |
| S | 154137 | 8.5% |
| D | 145228 | 8.0% |
| T | 95175 | 5.3% |
| O | 92338 | 5.1% |
| C | 91863 | 5.1% |
| M | 81221 | 4.5% |
| F | 75128 | 4.2% |
| W | 71354 | 3.9% |
| Other values (16) | 630302 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 206719 | 11.4% |
| L | 165496 | 9.1% |
| S | 154137 | 8.5% |
| D | 145228 | 8.0% |
| T | 95175 | 5.3% |
| O | 92338 | 5.1% |
| C | 91863 | 5.1% |
| M | 81221 | 4.5% |
| F | 75128 | 4.2% |
| W | 71354 | 3.9% |
| Other values (16) | 630302 |
DEST_CITY_NAME
Text
| Distinct | 331 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.045575 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7866312 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Minneapolis, MN |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Charlotte, NC |
| 4th row | Detroit, MI |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 65602 | 4.7% |
| tx | 64535 | 4.6% |
| fl | 48080 | 3.4% |
| il | 32295 | 2.3% |
| ny | 32080 | 2.3% |
| san | 32018 | 2.3% |
| ga | 31442 | 2.2% |
| chicago | 31239 | 2.2% |
| atlanta | 29428 | 2.1% |
| co | 29196 | 2.1% |
| Other values (402) | 1006177 |
Most occurring characters
| Value | Count | Frequency (%) |
| 799105 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600315 | 7.6% |
| o | 434207 | 5.5% |
| e | 415301 | 5.3% |
| n | 387055 | 4.9% |
| t | 379131 | 4.8% |
| l | 350493 | 4.5% |
| i | 300099 | 3.8% |
| r | 283234 | 3.6% |
| Other values (47) | 3314385 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7866312 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 799105 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600315 | 7.6% |
| o | 434207 | 5.5% |
| e | 415301 | 5.3% |
| n | 387055 | 4.9% |
| t | 379131 | 4.8% |
| l | 350493 | 4.5% |
| i | 300099 | 3.8% |
| r | 283234 | 3.6% |
| Other values (47) | 3314385 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7866312 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 799105 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600315 | 7.6% |
| o | 434207 | 5.5% |
| e | 415301 | 5.3% |
| n | 387055 | 4.9% |
| t | 379131 | 4.8% |
| l | 350493 | 4.5% |
| i | 300099 | 3.8% |
| r | 283234 | 3.6% |
| Other values (47) | 3314385 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7866312 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 799105 | 10.2% | |
| , | 602987 | 7.7% |
| a | 600315 | 7.6% |
| o | 434207 | 5.5% |
| e | 415301 | 5.3% |
| n | 387055 | 4.9% |
| t | 379131 | 4.8% |
| l | 350493 | 4.5% |
| i | 300099 | 3.8% |
| r | 283234 | 3.6% |
| Other values (47) | 3314385 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1786075 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4931594 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Minnesota |
|---|---|
| 2nd row | New York |
| 3rd row | North Carolina |
| 4th row | Michigan |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 65602 | 9.5% |
| texas | 64535 | 9.3% |
| florida | 48080 | 7.0% |
| new | 47078 | 6.8% |
| illinois | 32295 | 4.7% |
| york | 32080 | 4.6% |
| carolina | 31663 | 4.6% |
| georgia | 31442 | 4.6% |
| colorado | 29196 | 4.2% |
| north | 27364 | 4.0% |
| Other values (51) | 281321 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 662920 | |
| i | 553778 | 11.2% |
| o | 472617 | 9.6% |
| n | 370014 | 7.5% |
| r | 351574 | 7.1% |
| e | 300799 | 6.1% |
| s | 286836 | 5.8% |
| l | 272858 | 5.5% |
| C | 128293 | 2.6% |
| t | 120580 | 2.4% |
| Other values (37) | 1411325 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4931594 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 662920 | |
| i | 553778 | 11.2% |
| o | 472617 | 9.6% |
| n | 370014 | 7.5% |
| r | 351574 | 7.1% |
| e | 300799 | 6.1% |
| s | 286836 | 5.8% |
| l | 272858 | 5.5% |
| C | 128293 | 2.6% |
| t | 120580 | 2.4% |
| Other values (37) | 1411325 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4931594 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 662920 | |
| i | 553778 | 11.2% |
| o | 472617 | 9.6% |
| n | 370014 | 7.5% |
| r | 351574 | 7.1% |
| e | 300799 | 6.1% |
| s | 286836 | 5.8% |
| l | 272858 | 5.5% |
| C | 128293 | 2.6% |
| t | 120580 | 2.4% |
| Other values (37) | 1411325 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4931594 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 662920 | |
| i | 553778 | 11.2% |
| o | 472617 | 9.6% |
| n | 370014 | 7.5% |
| r | 351574 | 7.1% |
| e | 300799 | 6.1% |
| s | 286836 | 5.8% |
| l | 272858 | 5.5% |
| C | 128293 | 2.6% |
| t | 120580 | 2.4% |
| Other values (37) | 1411325 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.727848 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.916702 |
|---|---|
| Coefficient of variation (CV) | 0.49182825 |
| Kurtosis | -1.3082437 |
| Mean | 54.727848 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.049882221 |
| Sum | 33000181 |
| Variance | 724.50885 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 65602 | 10.9% |
| 74 | 64535 | 10.7% |
| 33 | 48080 | 8.0% |
| 41 | 32295 | 5.4% |
| 22 | 32080 | 5.3% |
| 34 | 31442 | 5.2% |
| 82 | 29196 | 4.8% |
| 36 | 25943 | 4.3% |
| 38 | 20980 | 3.5% |
| 93 | 18181 | 3.0% |
| Other values (42) | 234653 |
| Value | Count | Frequency (%) |
| 1 | 4060 | 0.7% |
| 2 | 11662 | |
| 3 | 3472 | 0.6% |
| 4 | 402 | 0.1% |
| 5 | 125 | < 0.1% |
| 11 | 1832 | 0.3% |
| 12 | 1793 | 0.3% |
| 13 | 13299 | |
| 14 | 600 | 0.1% |
| 15 | 1237 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 18181 | 3.0% |
| 92 | 6911 | 1.1% |
| 91 | 65602 | |
| 88 | 992 | 0.2% |
| 87 | 10133 | 1.7% |
| 86 | 2388 | 0.4% |
| 85 | 17859 | 3.0% |
| 84 | 2755 | 0.5% |
| 83 | 2356 | 0.4% |
| 82 | 29196 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1231 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1337.3947 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 910 |
| median | 1326 |
| Q3 | 1749 |
| 95-th percentile | 2140 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 839 |
Descriptive statistics
| Standard deviation | 501.90242 |
|---|---|
| Coefficient of variation (CV) | 0.37528369 |
| Kurtosis | -1.0842398 |
| Mean | 1337.3947 |
| Median Absolute Deviation (MAD) | 420 |
| Skewness | 0.078570331 |
| Sum | 8.0643163 × 108 |
| Variance | 251906.04 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 11869 | 2.0% |
| 700 | 8686 | 1.4% |
| 800 | 4907 | 0.8% |
| 630 | 3745 | 0.6% |
| 1000 | 3610 | 0.6% |
| 615 | 3454 | 0.6% |
| 730 | 3379 | 0.6% |
| 830 | 3357 | 0.6% |
| 900 | 3278 | 0.5% |
| 1100 | 2931 | 0.5% |
| Other values (1221) | 553771 |
| Value | Count | Frequency (%) |
| 1 | 7 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 10 | 63 | |
| 12 | 4 | < 0.1% |
| 14 | 4 | < 0.1% |
| 15 | 97 | |
| 18 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 1054 | |
| 2358 | 88 | < 0.1% |
| 2357 | 66 | < 0.1% |
| 2356 | 79 | < 0.1% |
| 2355 | 339 | 0.1% |
| 2354 | 38 | < 0.1% |
| 2353 | 49 | < 0.1% |
| 2352 | 43 | < 0.1% |
| 2351 | 26 | < 0.1% |
| 2350 | 140 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING 
| Distinct | 1419 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 8883 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1337.9642 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 557 |
| Q1 | 908 |
| median | 1328 |
| Q3 | 1756 |
| 95-th percentile | 2154 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 848 |
Descriptive statistics
| Standard deviation | 519.77457 |
|---|---|
| Coefficient of variation (CV) | 0.38848166 |
| Kurtosis | -0.9853093 |
| Mean | 1337.9642 |
| Median Absolute Deviation (MAD) | 424 |
| Skewness | 0.020838784 |
| Sum | 7.9488991 × 108 |
| Variance | 270165.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 555 | 1507 | 0.2% |
| 556 | 1463 | 0.2% |
| 557 | 1381 | 0.2% |
| 554 | 1265 | 0.2% |
| 558 | 1231 | 0.2% |
| 655 | 1177 | 0.2% |
| 600 | 1159 | 0.2% |
| 656 | 1157 | 0.2% |
| 559 | 1141 | 0.2% |
| 553 | 1123 | 0.2% |
| Other values (1409) | 581500 | |
| (Missing) | 8883 | 1.5% |
| Value | Count | Frequency (%) |
| 1 | 127 | |
| 2 | 102 | |
| 3 | 88 | |
| 4 | 87 | |
| 5 | 99 | |
| 6 | 66 | |
| 7 | 64 | |
| 8 | 71 | |
| 9 | 81 | |
| 10 | 82 |
| Value | Count | Frequency (%) |
| 2400 | 84 | |
| 2359 | 108 | |
| 2358 | 122 | |
| 2357 | 131 | |
| 2356 | 135 | |
| 2355 | 155 | |
| 2354 | 130 | |
| 2353 | 165 | |
| 2352 | 162 | |
| 2351 | 143 |
DEP_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1230 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 8886 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.245425 |
| Minimum | -59 |
|---|---|
| Maximum | 3445 |
| Zeros | 26621 |
| Zeros (%) | 4.4% |
| Negative | 333332 |
| Negative (%) | 55.3% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -59 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -5 |
| median | -2 |
| Q3 | 11 |
| 95-th percentile | 87 |
| Maximum | 3445 |
| Range | 3504 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 60.608499 |
|---|---|
| Coefficient of variation (CV) | 4.2545941 |
| Kurtosis | 255.5977 |
| Mean | 14.245425 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 11.630124 |
| Sum | 8463221 |
| Variance | 3673.3902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 43528 | 7.2% |
| -4 | 40213 | 6.7% |
| -3 | 38441 | 6.4% |
| -2 | 35020 | 5.8% |
| -6 | 34433 | 5.7% |
| -1 | 31248 | 5.2% |
| -7 | 29859 | 5.0% |
| 0 | 26621 | 4.4% |
| -8 | 23776 | 3.9% |
| -9 | 17994 | 3.0% |
| Other values (1220) | 272968 |
| Value | Count | Frequency (%) |
| -59 | 1 | < 0.1% |
| -53 | 1 | < 0.1% |
| -50 | 1 | < 0.1% |
| -47 | 1 | < 0.1% |
| -46 | 1 | < 0.1% |
| -43 | 1 | < 0.1% |
| -39 | 3 | |
| -37 | 1 | < 0.1% |
| -36 | 1 | < 0.1% |
| -35 | 2 |
| Value | Count | Frequency (%) |
| 3445 | 1 | |
| 3013 | 1 | |
| 2969 | 1 | |
| 2938 | 1 | |
| 2928 | 1 | |
| 2894 | 1 | |
| 2826 | 1 | |
| 2728 | 1 | |
| 2690 | 1 | |
| 2663 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING 
| Distinct | 168 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9137 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.263112 |
| Minimum | 1 |
|---|---|
| Maximum | 201 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 33 |
| Maximum | 201 |
| Range | 200 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 9.0961373 |
|---|---|
| Coefficient of variation (CV) | 0.52691179 |
| Kurtosis | 25.717888 |
| Mean | 17.263112 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.5903024 |
| Sum | 10251699 |
| Variance | 82.739713 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 49112 | 8.1% |
| 13 | 48646 | 8.1% |
| 14 | 45738 | 7.6% |
| 11 | 44963 | 7.5% |
| 15 | 41771 | 6.9% |
| 16 | 36566 | 6.1% |
| 10 | 36516 | 6.1% |
| 17 | 32187 | 5.3% |
| 18 | 27644 | 4.6% |
| 9 | 24929 | 4.1% |
| Other values (158) | 205778 |
| Value | Count | Frequency (%) |
| 1 | 6 | < 0.1% |
| 2 | 19 | < 0.1% |
| 3 | 60 | < 0.1% |
| 4 | 190 | < 0.1% |
| 5 | 564 | 0.1% |
| 6 | 2603 | 0.4% |
| 7 | 7097 | 1.2% |
| 8 | 14336 | 2.4% |
| 9 | 24929 | |
| 10 | 36516 |
| Value | Count | Frequency (%) |
| 201 | 1 | |
| 199 | 1 | |
| 176 | 1 | |
| 171 | 1 | |
| 168 | 1 | |
| 167 | 1 | |
| 166 | 1 | |
| 165 | 2 | |
| 162 | 2 | |
| 161 | 2 |
TAXI_IN
Real number (ℝ)
MISSING 
| Distinct | 167 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9272 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2480146 |
| Minimum | 1 |
|---|---|
| Maximum | 223 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 19 |
| Maximum | 223 |
| Range | 222 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 6.7648931 |
|---|---|
| Coefficient of variation (CV) | 0.82018442 |
| Kurtosis | 56.427251 |
| Mean | 8.2480146 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.0075367 |
| Sum | 4896970 |
| Variance | 45.763778 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 87288 | |
| 5 | 84861 | |
| 6 | 70331 | |
| 7 | 57031 | |
| 3 | 50085 | |
| 8 | 44035 | |
| 9 | 34534 | 5.7% |
| 10 | 27095 | 4.5% |
| 11 | 21595 | 3.6% |
| 12 | 17110 | 2.8% |
| Other values (157) | 99750 |
| Value | Count | Frequency (%) |
| 1 | 748 | 0.1% |
| 2 | 11947 | 2.0% |
| 3 | 50085 | |
| 4 | 87288 | |
| 5 | 84861 | |
| 6 | 70331 | |
| 7 | 57031 | |
| 8 | 44035 | |
| 9 | 34534 | 5.7% |
| 10 | 27095 | 4.5% |
| Value | Count | Frequency (%) |
| 223 | 1 | |
| 189 | 1 | |
| 188 | 2 | |
| 182 | 2 | |
| 181 | 1 | |
| 179 | 1 | |
| 178 | 1 | |
| 173 | 2 | |
| 172 | 1 | |
| 171 | 2 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1312 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1479.811 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 702 |
| Q1 | 1050 |
| median | 1511 |
| Q3 | 1927 |
| 95-th percentile | 2300 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 877 |
Descriptive statistics
| Standard deviation | 535.16184 |
|---|---|
| Coefficient of variation (CV) | 0.36164201 |
| Kurtosis | -0.48340853 |
| Mean | 1479.811 |
| Median Absolute Deviation (MAD) | 424 |
| Skewness | -0.31014863 |
| Sum | 8.9230682 × 108 |
| Variance | 286398.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2359 | 3603 | 0.6% |
| 1810 | 2162 | 0.4% |
| 2000 | 1872 | 0.3% |
| 2100 | 1825 | 0.3% |
| 1940 | 1746 | 0.3% |
| 1655 | 1737 | 0.3% |
| 1900 | 1732 | 0.3% |
| 1400 | 1722 | 0.3% |
| 1030 | 1655 | 0.3% |
| 2200 | 1654 | 0.3% |
| Other values (1302) | 583279 |
| Value | Count | Frequency (%) |
| 1 | 70 | < 0.1% |
| 2 | 84 | < 0.1% |
| 3 | 201 | < 0.1% |
| 4 | 162 | < 0.1% |
| 5 | 571 | |
| 6 | 109 | < 0.1% |
| 7 | 151 | < 0.1% |
| 8 | 104 | < 0.1% |
| 9 | 134 | < 0.1% |
| 10 | 578 |
| Value | Count | Frequency (%) |
| 2359 | 3603 | |
| 2358 | 753 | 0.1% |
| 2357 | 753 | 0.1% |
| 2356 | 523 | 0.1% |
| 2355 | 1203 | 0.2% |
| 2354 | 384 | 0.1% |
| 2353 | 563 | 0.1% |
| 2352 | 496 | 0.1% |
| 2351 | 492 | 0.1% |
| 2350 | 840 | 0.1% |
ARR_TIME
Real number (ℝ)
MISSING 
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 9272 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1446.2754 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 559 |
| Q1 | 1030 |
| median | 1453 |
| Q3 | 1919 |
| 95-th percentile | 2256 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 889 |
Descriptive statistics
| Standard deviation | 562.05235 |
|---|---|
| Coefficient of variation (CV) | 0.38862056 |
| Kurtosis | -0.41419961 |
| Mean | 1446.2754 |
| Median Absolute Deviation (MAD) | 443 |
| Skewness | -0.38008702 |
| Sum | 8.586754 × 108 |
| Variance | 315902.85 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1637 | 690 | 0.1% |
| 1147 | 668 | 0.1% |
| 1139 | 658 | 0.1% |
| 2130 | 655 | 0.1% |
| 1141 | 651 | 0.1% |
| 1717 | 649 | 0.1% |
| 1647 | 648 | 0.1% |
| 1629 | 647 | 0.1% |
| 1143 | 647 | 0.1% |
| 2132 | 647 | 0.1% |
| Other values (1430) | 587155 | |
| (Missing) | 9272 | 1.5% |
| Value | Count | Frequency (%) |
| 1 | 431 | |
| 2 | 378 | |
| 3 | 363 | |
| 4 | 377 | |
| 5 | 362 | |
| 6 | 367 | |
| 7 | 372 | |
| 8 | 399 | |
| 9 | 338 | |
| 10 | 362 |
| Value | Count | Frequency (%) |
| 2400 | 358 | |
| 2359 | 476 | |
| 2358 | 439 | |
| 2357 | 433 | |
| 2356 | 419 | |
| 2355 | 424 | |
| 2354 | 435 | |
| 2353 | 447 | |
| 2352 | 497 | |
| 2351 | 456 |
ARR_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1263 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 10845 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.440266 |
| Minimum | -84 |
|---|---|
| Maximum | 3424 |
| Zeros | 10607 |
| Zeros (%) | 1.8% |
| Negative | 360676 |
| Negative (%) | 59.8% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -84 |
|---|---|
| 5-th percentile | -27 |
| Q1 | -15 |
| median | -6 |
| Q3 | 10 |
| 95-th percentile | 86 |
| Maximum | 3424 |
| Range | 3508 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 62.230354 |
|---|---|
| Coefficient of variation (CV) | 7.3730323 |
| Kurtosis | 231.78412 |
| Mean | 8.440266 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 10.835245 |
| Sum | 4997836 |
| Variance | 3872.6169 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -11 | 16682 | 2.8% |
| -10 | 16603 | 2.8% |
| -13 | 16574 | 2.7% |
| -12 | 16424 | 2.7% |
| -9 | 16222 | 2.7% |
| -8 | 15946 | 2.6% |
| -14 | 15917 | 2.6% |
| -15 | 15485 | 2.6% |
| -7 | 15435 | 2.6% |
| -16 | 14801 | 2.5% |
| Other values (1253) | 432053 |
| Value | Count | Frequency (%) |
| -84 | 1 | < 0.1% |
| -83 | 1 | < 0.1% |
| -81 | 1 | < 0.1% |
| -80 | 2 | |
| -79 | 3 | |
| -78 | 2 | |
| -77 | 2 | |
| -76 | 1 | < 0.1% |
| -73 | 4 | |
| -72 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3424 | 1 | |
| 2998 | 1 | |
| 2962 | 1 | |
| 2923 | 1 | |
| 2913 | 1 | |
| 2910 | 1 | |
| 2815 | 1 | |
| 2721 | 1 | |
| 2685 | 1 | |
| 2653 | 1 |
CANCELLED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 9172 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1808961 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 593815 | |
| 1.0 | 9172 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 593815 | |
| 1.0 | 9172 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1196802 | |
| . | 602987 | |
| 1 | 9172 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1196802 | |
| . | 602987 | |
| 1 | 9172 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1196802 | |
| . | 602987 | |
| 1 | 9172 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1196802 | |
| . | 602987 | |
| 1 | 9172 | 0.5% |
CANCELLATION_CODE
Categorical
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 593815 |
| Missing (%) | 98.5% |
| Memory size | 4.6 MiB |
| B | |
|---|---|
| A | |
| C |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9172 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | B |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| B | 5865 | 1.0% |
| A | 2381 | 0.4% |
| C | 926 | 0.2% |
| (Missing) | 593815 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 5865 | |
| a | 2381 | |
| c | 926 | 10.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 5865 | |
| A | 2381 | |
| C | 926 | 10.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9172 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 5865 | |
| A | 2381 | |
| C | 926 | 10.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9172 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 5865 | |
| A | 2381 | |
| C | 926 | 10.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9172 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 5865 | |
| A | 2381 | |
| C | 926 | 10.1% |
DIVERTED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1673 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1808961 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 601314 | |
| 1.0 | 1673 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 601314 | |
| 1.0 | 1673 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1204301 | |
| . | 602987 | |
| 1 | 1673 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1204301 | |
| . | 602987 | |
| 1 | 1673 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1204301 | |
| . | 602987 | |
| 1 | 1673 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1808961 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1204301 | |
| . | 602987 | |
| 1 | 1673 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING 
| Distinct | 593 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 10845 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.15247 |
| Minimum | 8 |
|---|---|
| Maximum | 656 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 62 |
| median | 96 |
| Q3 | 143 |
| 95-th percentile | 271 |
| Maximum | 656 |
| Range | 648 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 70.410635 |
|---|---|
| Coefficient of variation (CV) | 0.61681221 |
| Kurtosis | 2.0607336 |
| Mean | 114.15247 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 1.3590136 |
| Sum | 67594469 |
| Variance | 4957.6575 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 5085 | 0.8% |
| 63 | 5024 | 0.8% |
| 61 | 5016 | 0.8% |
| 64 | 4999 | 0.8% |
| 60 | 4913 | 0.8% |
| 65 | 4838 | 0.8% |
| 59 | 4830 | 0.8% |
| 54 | 4805 | 0.8% |
| 66 | 4771 | 0.8% |
| 58 | 4764 | 0.8% |
| Other values (583) | 543097 | |
| (Missing) | 10845 | 1.8% |
| Value | Count | Frequency (%) |
| 8 | 9 | < 0.1% |
| 9 | 17 | < 0.1% |
| 10 | 19 | < 0.1% |
| 11 | 10 | < 0.1% |
| 12 | 3 | < 0.1% |
| 13 | 7 | < 0.1% |
| 14 | 16 | < 0.1% |
| 15 | 24 | < 0.1% |
| 16 | 93 | |
| 17 | 210 |
| Value | Count | Frequency (%) |
| 656 | 1 | < 0.1% |
| 644 | 2 | |
| 642 | 2 | |
| 641 | 3 | |
| 640 | 1 | < 0.1% |
| 639 | 1 | < 0.1% |
| 637 | 2 | |
| 635 | 1 | < 0.1% |
| 633 | 2 | |
| 631 | 2 |
CARRIER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 955 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 474548 |
| Missing (%) | 78.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.88382 |
| Minimum | 0 |
|---|---|
| Maximum | 3424 |
| Zeros | 55325 |
| Zeros (%) | 9.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 23 |
| 95-th percentile | 108.1 |
| Maximum | 3424 |
| Range | 3424 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 84.94507 |
|---|---|
| Coefficient of variation (CV) | 3.1597098 |
| Kurtosis | 214.81089 |
| Mean | 26.88382 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 11.258762 |
| Sum | 3452931 |
| Variance | 7215.6649 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 55325 | 9.2% |
| 1 | 2348 | 0.4% |
| 2 | 2338 | 0.4% |
| 3 | 2286 | 0.4% |
| 6 | 2265 | 0.4% |
| 15 | 2207 | 0.4% |
| 4 | 2129 | 0.4% |
| 7 | 2122 | 0.4% |
| 5 | 2117 | 0.4% |
| 8 | 1948 | 0.3% |
| Other values (945) | 53354 | 8.8% |
| (Missing) | 474548 |
| Value | Count | Frequency (%) |
| 0 | 55325 | |
| 1 | 2348 | 0.4% |
| 2 | 2338 | 0.4% |
| 3 | 2286 | 0.4% |
| 4 | 2129 | 0.4% |
| 5 | 2117 | 0.4% |
| 6 | 2265 | 0.4% |
| 7 | 2122 | 0.4% |
| 8 | 1948 | 0.3% |
| 9 | 1810 | 0.3% |
| Value | Count | Frequency (%) |
| 3424 | 1 | |
| 2998 | 1 | |
| 2962 | 1 | |
| 2923 | 1 | |
| 2913 | 1 | |
| 2894 | 1 | |
| 2815 | 1 | |
| 2721 | 1 | |
| 2685 | 1 | |
| 2653 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 429 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 474548 |
| Missing (%) | 78.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7365286 |
| Minimum | 0 |
|---|---|
| Maximum | 1561 |
| Zeros | 120952 |
| Zeros (%) | 20.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 10 |
| Maximum | 1561 |
| Range | 1561 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 28.404783 |
|---|---|
| Coefficient of variation (CV) | 7.6019176 |
| Kurtosis | 561.3963 |
| Mean | 3.7365286 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.219888 |
| Sum | 479916 |
| Variance | 806.83169 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 120952 | 20.1% |
| 15 | 170 | < 0.1% |
| 19 | 146 | < 0.1% |
| 16 | 144 | < 0.1% |
| 17 | 138 | < 0.1% |
| 18 | 135 | < 0.1% |
| 9 | 133 | < 0.1% |
| 20 | 133 | < 0.1% |
| 23 | 131 | < 0.1% |
| 22 | 126 | < 0.1% |
| Other values (419) | 6231 | 1.0% |
| (Missing) | 474548 |
| Value | Count | Frequency (%) |
| 0 | 120952 | |
| 1 | 91 | < 0.1% |
| 2 | 97 | < 0.1% |
| 3 | 97 | < 0.1% |
| 4 | 99 | < 0.1% |
| 5 | 102 | < 0.1% |
| 6 | 117 | < 0.1% |
| 7 | 124 | < 0.1% |
| 8 | 121 | < 0.1% |
| 9 | 133 | < 0.1% |
| Value | Count | Frequency (%) |
| 1561 | 1 | |
| 1251 | 1 | |
| 1226 | 1 | |
| 1190 | 1 | |
| 1166 | 1 | |
| 1103 | 2 | |
| 1056 | 2 | |
| 1038 | 1 | |
| 1035 | 1 | |
| 990 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 419 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 474548 |
| Missing (%) | 78.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.504185 |
| Minimum | 0 |
|---|---|
| Maximum | 1316 |
| Zeros | 72188 |
| Zeros (%) | 12.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 14 |
| 95-th percentile | 52 |
| Maximum | 1316 |
| Range | 1316 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 29.91226 |
|---|---|
| Coefficient of variation (CV) | 2.6001199 |
| Kurtosis | 225.86876 |
| Mean | 11.504185 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.223394 |
| Sum | 1477586 |
| Variance | 894.74331 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 72188 | 12.0% |
| 1 | 3422 | 0.6% |
| 2 | 2405 | 0.4% |
| 3 | 2193 | 0.4% |
| 4 | 2045 | 0.3% |
| 15 | 2028 | 0.3% |
| 5 | 1979 | 0.3% |
| 16 | 1825 | 0.3% |
| 6 | 1785 | 0.3% |
| 17 | 1669 | 0.3% |
| Other values (409) | 36900 | 6.1% |
| (Missing) | 474548 |
| Value | Count | Frequency (%) |
| 0 | 72188 | |
| 1 | 3422 | 0.6% |
| 2 | 2405 | 0.4% |
| 3 | 2193 | 0.4% |
| 4 | 2045 | 0.3% |
| 5 | 1979 | 0.3% |
| 6 | 1785 | 0.3% |
| 7 | 1652 | 0.3% |
| 8 | 1669 | 0.3% |
| 9 | 1474 | 0.2% |
| Value | Count | Frequency (%) |
| 1316 | 1 | |
| 1227 | 1 | |
| 1108 | 1 | |
| 1084 | 1 | |
| 1041 | 1 | |
| 1027 | 1 | |
| 1020 | 1 | |
| 981 | 1 | |
| 962 | 1 | |
| 937 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 103 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 474548 |
| Missing (%) | 78.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16595427 |
| Minimum | 0 |
|---|---|
| Maximum | 805 |
| Zeros | 127603 |
| Zeros (%) | 21.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 805 |
| Range | 805 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.6060325 |
|---|---|
| Coefficient of variation (CV) | 21.729074 |
| Kurtosis | 19792.056 |
| Mean | 0.16595427 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 101.13223 |
| Sum | 21315 |
| Variance | 13.00347 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 127603 | 21.2% |
| 15 | 40 | < 0.1% |
| 17 | 35 | < 0.1% |
| 16 | 34 | < 0.1% |
| 14 | 30 | < 0.1% |
| 20 | 28 | < 0.1% |
| 5 | 27 | < 0.1% |
| 10 | 27 | < 0.1% |
| 7 | 27 | < 0.1% |
| 3 | 26 | < 0.1% |
| Other values (93) | 562 | 0.1% |
| (Missing) | 474548 |
| Value | Count | Frequency (%) |
| 0 | 127603 | |
| 1 | 18 | < 0.1% |
| 2 | 16 | < 0.1% |
| 3 | 26 | < 0.1% |
| 4 | 15 | < 0.1% |
| 5 | 27 | < 0.1% |
| 6 | 18 | < 0.1% |
| 7 | 27 | < 0.1% |
| 8 | 19 | < 0.1% |
| 9 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 805 | 1 | |
| 187 | 1 | |
| 178 | 1 | |
| 173 | 1 | |
| 171 | 1 | |
| 170 | 1 | |
| 138 | 1 | |
| 136 | 1 | |
| 135 | 1 | |
| 126 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 792 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 474548 |
| Missing (%) | 78.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.897593 |
| Minimum | 0 |
|---|---|
| Maximum | 1865 |
| Zeros | 59380 |
| Zeros (%) | 9.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 6 |
| Q3 | 35 |
| 95-th percentile | 132 |
| Maximum | 1865 |
| Range | 1865 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 68.645197 |
|---|---|
| Coefficient of variation (CV) | 2.2217005 |
| Kurtosis | 92.569107 |
| Mean | 30.897593 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 7.3588678 |
| Sum | 3968456 |
| Variance | 4712.1631 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 59380 | 9.8% |
| 15 | 1726 | 0.3% |
| 16 | 1542 | 0.3% |
| 17 | 1496 | 0.2% |
| 18 | 1461 | 0.2% |
| 20 | 1312 | 0.2% |
| 19 | 1296 | 0.2% |
| 21 | 1252 | 0.2% |
| 22 | 1231 | 0.2% |
| 14 | 1184 | 0.2% |
| Other values (782) | 56559 | 9.4% |
| (Missing) | 474548 |
| Value | Count | Frequency (%) |
| 0 | 59380 | |
| 1 | 844 | 0.1% |
| 2 | 847 | 0.1% |
| 3 | 838 | 0.1% |
| 4 | 861 | 0.1% |
| 5 | 884 | 0.1% |
| 6 | 951 | 0.2% |
| 7 | 925 | 0.2% |
| 8 | 962 | 0.2% |
| 9 | 1003 | 0.2% |
| Value | Count | Frequency (%) |
| 1865 | 1 | |
| 1790 | 1 | |
| 1722 | 1 | |
| 1703 | 1 | |
| 1565 | 1 | |
| 1521 | 1 | |
| 1387 | 1 | |
| 1382 | 1 | |
| 1371 | 1 | |
| 1360 | 1 |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 8/7/2023 12:00:00 AM | 9E | 4900 | 14524 | RIC | Richmond, VA | Virginia | 38 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 619 | 614.0 | -5.0 | 16.0 | 5.0 | 819 | 810.0 | -9.0 | 0.0 | NaN | 0.0 | 155.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 8/7/2023 12:00:00 AM | 9E | 4901 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12478 | JFK | New York, NY | New York | 22 | 1955 | NaN | NaN | NaN | NaN | 2210 | NaN | NaN | 1.0 | B | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 8/7/2023 12:00:00 AM | 9E | 4901 | 12478 | JFK | New York, NY | New York | 22 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 1629 | NaN | NaN | NaN | NaN | 1907 | NaN | NaN | 1.0 | B | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 8/7/2023 12:00:00 AM | 9E | 4902 | 15096 | SYR | Syracuse, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 615 | 615.0 | 0.0 | 11.0 | 7.0 | 746 | 735.0 | -11.0 | 0.0 | NaN | 0.0 | 62.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 8/7/2023 12:00:00 AM | 9E | 4903 | 10599 | BHM | Birmingham, AL | Alabama | 51 | 12953 | LGA | New York, NY | New York | 22 | 1109 | 1105.0 | -4.0 | 22.0 | 13.0 | 1441 | 1435.0 | -6.0 | 0.0 | NaN | 0.0 | 115.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 8/7/2023 12:00:00 AM | 9E | 4903 | 12953 | LGA | New York, NY | New York | 22 | 10599 | BHM | Birmingham, AL | Alabama | 51 | 841 | 832.0 | -9.0 | 22.0 | 6.0 | 1022 | 1005.0 | -17.0 | 0.0 | NaN | 0.0 | 125.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 8/7/2023 12:00:00 AM | 9E | 4904 | 10581 | BGR | Bangor, ME | Maine | 12 | 12953 | LGA | New York, NY | New York | 22 | 1221 | 1215.0 | -6.0 | 9.0 | 6.0 | 1404 | 1336.0 | -28.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 8/7/2023 12:00:00 AM | 9E | 4904 | 12953 | LGA | New York, NY | New York | 22 | 10581 | BGR | Bangor, ME | Maine | 12 | 945 | 935.0 | -10.0 | 14.0 | 18.0 | 1134 | 1100.0 | -34.0 | 0.0 | NaN | 0.0 | 53.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 8/7/2023 12:00:00 AM | 9E | 4905 | 12953 | LGA | New York, NY | New York | 22 | 11267 | DAY | Dayton, OH | Ohio | 44 | 2000 | 2033.0 | 33.0 | 45.0 | 6.0 | 2207 | 2305.0 | 58.0 | 0.0 | NaN | 0.0 | 101.0 | 0.0 | 0.0 | 58.0 | 0.0 | 0.0 |
| 9 | 1 | 8/7/2023 12:00:00 AM | 9E | 4906 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 13377 | MLU | Monroe, LA | Louisiana | 72 | 1005 | 1000.0 | -5.0 | 15.0 | 2.0 | 1043 | 1025.0 | -18.0 | 0.0 | NaN | 0.0 | 68.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 602977 | 7 | 8/27/2023 12:00:00 AM | YX | 5832 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 12953 | LGA | New York, NY | New York | 22 | 1405 | 1400.0 | -5.0 | 17.0 | 28.0 | 1610 | 1611.0 | 1.0 | 0.0 | NaN | 0.0 | 86.0 | NaN | NaN | NaN | NaN | NaN |
| 602978 | 7 | 8/27/2023 12:00:00 AM | YX | 5832 | 12953 | LGA | New York, NY | New York | 22 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 1051 | 1046.0 | -5.0 | 15.0 | 6.0 | 1317 | 1249.0 | -28.0 | 0.0 | NaN | 0.0 | 102.0 | NaN | NaN | NaN | NaN | NaN |
| 602979 | 7 | 8/27/2023 12:00:00 AM | YX | 5833 | 12478 | JFK | New York, NY | New York | 22 | 11066 | CMH | Columbus, OH | Ohio | 44 | 2130 | 2122.0 | -8.0 | 48.0 | 4.0 | 2335 | 2332.0 | -3.0 | 0.0 | NaN | 0.0 | 78.0 | NaN | NaN | NaN | NaN | NaN |
| 602980 | 7 | 8/27/2023 12:00:00 AM | YX | 5834 | 12953 | LGA | New York, NY | New York | 22 | 13485 | MSN | Madison, WI | Wisconsin | 45 | 2050 | 2050.0 | 0.0 | 24.0 | 5.0 | 2224 | 2220.0 | -4.0 | 0.0 | NaN | 0.0 | 121.0 | NaN | NaN | NaN | NaN | NaN |
| 602981 | 7 | 8/27/2023 12:00:00 AM | YX | 5837 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12478 | JFK | New York, NY | New York | 22 | 635 | 629.0 | -6.0 | 21.0 | 9.0 | 849 | 817.0 | -32.0 | 0.0 | NaN | 0.0 | 78.0 | NaN | NaN | NaN | NaN | NaN |
| 602982 | 7 | 8/27/2023 12:00:00 AM | YX | 5838 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1700 | 1654.0 | -6.0 | 17.0 | 19.0 | 1935 | 1921.0 | -14.0 | 0.0 | NaN | 0.0 | 111.0 | NaN | NaN | NaN | NaN | NaN |
| 602983 | 7 | 8/27/2023 12:00:00 AM | YX | 5839 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11066 | CMH | Columbus, OH | Ohio | 44 | 1400 | 1409.0 | 9.0 | 19.0 | 7.0 | 1615 | 1619.0 | 4.0 | 0.0 | NaN | 0.0 | 104.0 | NaN | NaN | NaN | NaN | NaN |
| 602984 | 7 | 8/27/2023 12:00:00 AM | YX | 5844 | 12953 | LGA | New York, NY | New York | 22 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1100 | 1056.0 | -4.0 | 24.0 | 11.0 | 1230 | 1207.0 | -23.0 | 0.0 | NaN | 0.0 | 36.0 | NaN | NaN | NaN | NaN | NaN |
| 602985 | 7 | 8/27/2023 12:00:00 AM | YX | 5845 | 10154 | ACK | Nantucket, MA | Massachusetts | 13 | 12478 | JFK | New York, NY | New York | 22 | 1152 | 1143.0 | -9.0 | 10.0 | 7.0 | 1309 | 1244.0 | -25.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |
| 602986 | 7 | 8/27/2023 12:00:00 AM | YX | 5846 | 11066 | CMH | Columbus, OH | Ohio | 44 | 12478 | JFK | New York, NY | New York | 22 | 1145 | 1143.0 | -2.0 | 12.0 | 15.0 | 1359 | 1332.0 | -27.0 | 0.0 | NaN | 0.0 | 82.0 | NaN | NaN | NaN | NaN | NaN |